-- phpMyAdmin SQL Dump
-- version 4.1.6
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 03, 2016 at 09:06 AM
-- Server version: 5.6.16
-- PHP Version: 5.5.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `urlshort`
--

-- --------------------------------------------------------

--
-- Table structure for table `urltable`
--

CREATE TABLE IF NOT EXISTS `urltable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `link` varchar(30) NOT NULL,
  `fullurl` varchar(600) NOT NULL,
  `owner` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;

--
-- Dumping data for table `urltable`
--

INSERT INTO `urltable` (`id`, `link`, `fullurl`, `owner`) VALUES
(28, 'Ho', 'http://stackoverflow.com/questions/18490026/refresh-reload-the-content-in-div-using-jquery-ajax', 9),
(29, 'EM', 'https://sim.petra.ac.id/petragate/index.php', 9),
(30, 'AK', 'https://web.whatsapp.com/', 9),
(31, 'Ho', 'http://stackoverflow.com/questions/18490026/refresh-reload-the-content-in-div-using-jquery-ajax', 9),
(35, 'Ho', 'http://stackoverflow.com/questions/18490026/refresh-reload-the-content-in-div-using-jquery-ajax', 10),
(38, 'Fr', 'http://www.w3schools.com/php/func_mysqli_error.asp', 10),
(39, 'ER', 'https://www.google.co.id/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=delete%20css%20jquery', 10),
(40, 'Ho', 'http://stackoverflow.com/questions/170997/what-is-the-best-way-to-remove-a-table-row-with-jquery', -1),
(41, 'Ho', 'http://stackoverflow.com/questions/2820723/how-to-get-base-url-with-php', 11);

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `no` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(30) NOT NULL,
  `pass` varchar(60) NOT NULL,
  PRIMARY KEY (`no`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`no`, `uname`, `pass`) VALUES
(7, 'ark', 'c20ad4d76fe97759aa27a0c99bff6710'),
(8, 'arr', 'c4ca4238a0b923820dcc509a6f75849b'),
(9, 'admin', '21232f297a57a5a743894a0e4a801fc3'),
(10, '123', '202cb962ac59075b964b07152d234b70'),
(11, 'dhia', '0cc175b9c0f1b6a831c399e269772661');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
